﻿CREATE TABLE [dbo].[SiteForm] (
    [id]            INT            IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CompanyId]     INT            NULL,
    [OrderId]       NVARCHAR (50)  NULL,
    [ProductId]     INT            NULL,
    [CustomerId]    NVARCHAR (50)  NULL,
    [CustomerName]  NVARCHAR (100) NULL,
    [ContactPerson] NVARCHAR (50)  NULL,
    [ContactTel]    NVARCHAR (20)  NULL,
    [SignDate]      DATETIME       NULL,
    [WebSitePrice]  NUMERIC (18)   NULL,
    [Description]   VARCHAR (MAX)  NULL,
    [StateId]       INT            CONSTRAINT [DF_SiteForm_StateId] DEFAULT (1) NULL,
    [CreateTime]    DATETIME       NULL,
    CONSTRAINT [PK_SiteForm] PRIMARY KEY CLUSTERED ([id] ASC)
);

